Tabela Treatment

Definicja tabeli Treatment

Name

Treatment

Code

Treatment

Comment

 


Lista kolumn tabeli Treatment

Name

Code

TreatmentID

TreatmentID

TreatmentTypeID

TreatmentTypeID

TreatmentResultID

TreatmentResultID

InfectionID

InfectionID

ServID

ServID

PerfServiceID

PerfServiceID

ResourceID

ResourceID

UnitID

UnitID

FrequencyID

FrequencyID

ApplicationWayID

ApplicationWayID

Active

Active

StartDT

StartDT

StopDT

StopDT

Comments

Comments

OtherTreatmentType

OtherTreatmentType

PatientIsolation

PatientIsolation

ICDCode

ICDCode

TreatmentResource

TreatmentResource

TreatmentDescr

TreatmentDescr

TreatmentDuration

TreatmentDuration

TreatmentResultDT

TreatmentResultDT

SourceOrgUnitID

SourceOrgUnitID

UnitsCount

UnitsCount


Kolumna TreatmentID tabeli Treatment

Definicja kolumny TreatmentID tabeli Treatment

Name

TreatmentID

Code

TreatmentID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TreatmentTypeID tabeli Treatment

Definicja kolumny TreatmentTypeID tabeli Treatment

Name

TreatmentTypeID

Code

TreatmentTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna TreatmentResultID tabeli Treatment

Definicja kolumny TreatmentResultID tabeli Treatment

Name

TreatmentResultID

Code

TreatmentResultID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna InfectionID tabeli Treatment

Definicja kolumny InfectionID tabeli Treatment

Name

InfectionID

Code

InfectionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ServID tabeli Treatment

Definicja kolumny ServID tabeli Treatment

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PerfServiceID tabeli Treatment

Definicja kolumny PerfServiceID tabeli Treatment

Name

PerfServiceID

Code

PerfServiceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceID tabeli Treatment

Definicja kolumny ResourceID tabeli Treatment

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator zasobu , leku podanego


Kolumna UnitID tabeli Treatment

Definicja kolumny UnitID tabeli Treatment

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator jednostki podanego zasobu


Kolumna FrequencyID tabeli Treatment

Definicja kolumny FrequencyID tabeli Treatment

Name

FrequencyID

Code

FrequencyID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator czestotliwosci podanego zasobu


Kolumna ApplicationWayID tabeli Treatment

Definicja kolumny ApplicationWayID tabeli Treatment

Name

ApplicationWayID

Code

ApplicationWayID

Data Type

NUMBER(10)

Mandatory

No

Comment

Identyfikator drogi podania zasobu


Kolumna Active tabeli Treatment

Definicja kolumny Active tabeli Treatment

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna StartDT tabeli Treatment

Definicja kolumny StartDT tabeli Treatment

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli Treatment

Definicja kolumny StopDT tabeli Treatment

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Comments tabeli Treatment

Definicja kolumny Comments tabeli Treatment

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna OtherTreatmentType tabeli Treatment

Definicja kolumny OtherTreatmentType tabeli Treatment

Name

OtherTreatmentType

Code

OtherTreatmentType

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna PatientIsolation tabeli Treatment

Definicja kolumny PatientIsolation tabeli Treatment

Name

PatientIsolation

Code

PatientIsolation

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ICDCode tabeli Treatment

Definicja kolumny ICDCode tabeli Treatment

Name

ICDCode

Code

ICDCode

Data Type

VARCHAR2(15)

Mandatory

No

Comment

 


Kolumna TreatmentResource tabeli Treatment

Definicja kolumny TreatmentResource tabeli Treatment

Name

TreatmentResource

Code

TreatmentResource

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna TreatmentDescr tabeli Treatment

Definicja kolumny TreatmentDescr tabeli Treatment

Name

TreatmentDescr

Code

TreatmentDescr

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna TreatmentDuration tabeli Treatment

Definicja kolumny TreatmentDuration tabeli Treatment

Name

TreatmentDuration

Code

TreatmentDuration

Data Type

NUMBER(10)

Mandatory

No

Comment

Dlugosc trwania leczenia


Kolumna TreatmentResultDT tabeli Treatment

Definicja kolumny TreatmentResultDT tabeli Treatment

Name

TreatmentResultDT

Code

TreatmentResultDT

Data Type

DATE

Mandatory

No

Comment

Data wyniku leczenia zakazenia


Kolumna SourceOrgUnitID tabeli Treatment

Definicja kolumny SourceOrgUnitID tabeli Treatment

Name

SourceOrgUnitID

Code

SourceOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

Jednoska zewnetrzna do której przeniesiono pacjenta po leczeniu zakazenia


Kolumna UnitsCount tabeli Treatment

Definicja kolumny UnitsCount tabeli Treatment

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(10)

Mandatory

No

Comment

Ilosc jednostek podanego zasobu


Lista kluczy tabeli Treatment

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli Treatment

Definicja klucza Identifier_1 tabeli Treatment

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment